<?php

namespace app\admin\model\ceshi;

use think\Model;


class Category extends Model
{

 

    // 表名
    protected $name = 'category';
    
    // 自动写入时间戳字段
    protected $autoWriteTimestamp = 'integer';

    // 定义时间戳字段名
    protected $createTime = 'createtime';
    protected $updateTime = 'updatetime';
    protected $deleteTime = false;
    

    //获取指定分类所有父ID号

function getAllFcateIds($categoryID)

{

//初始化ID数组

$array[] = $categoryID;

do

{

$ids = '';

$where['id'] = array('in',$categoryID);

$cate = M('cate')->where($where)->select();

echo M('cate')->_sql();

foreach ($cate as $v)

{

$array[] = $v['pid'];

$ids .= ',' . $v['pid'];

}

$ids = substr($ids, 1, strlen($ids));

$categoryID = $ids;

}

while (!empty($cate));

$ids = implode(',', $array);

return $ids;   //  返回字符串

//return $array //返回数组

}

//获取指定分类的所有子分类 键为ID，值为分类名

function getCateKv($categoryID)

{

//初始化ID数组,赋值当前分类

        $array[] = M('cate')->where("id={$categoryID}")->getField("cateName");

do

{

$ids = '';

$where['pid'] = array('in',$categoryID);

$cate = M('cate')->where($where)->select();

echo M('cate')->_sql();

foreach ($cate as $k=>$v)

{

$array[$v['id']] = $v['cateName'];

$ids .= ',' . $v['id'];

}

$ids = substr($ids, 1, strlen($ids));

$categoryID = $ids;

}

while (!empty($cate));

$ids = implode(',', $array);

//return $ids; //  返回字符串

return $array; //返回数组

}

}